package com.system.data.dao;

import com.system.data.model.NywProductsInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface NywDao {
    @Select("select * from nyw_products_info,nyw_cate_info where nyw_products_info.id=nyw_cate_info.id and nyw_cate_info.spName=#{cate} and nyw_products_info.marketDate=#{date};")
    List<NywProductsInfo> findNywProductsInfoByCateDate(@Param("cate") String cate,@Param("date") String date);
}
